﻿CREATE TABLE NetBee_Task (
    Id int primary key NOT NULL,
    Name varchar(100)  NOT NULL
);

CREATE TABLE NetBee_GatherRules (
    Id int primary key NOT NULL,
    Name varchar(32)  NOT NULL,
    Regexpression varchar(2048)  NOT NULL,
    TaskId int  NOT NULL
);

CREATE TABLE NetBee_GatherData (
    Id int primary key NOT NULL,
    TaskId int  NOT NULL,
    Data longtext  NOT NULL
);

CREATE TABLE NetBee_Url (
    Id int primary key NOT NULL,
    TaskId int  NOT NULL,
    Url longtext  NOT NULL,
    Status int  NOT NULL
);

CREATE TABLE NetBee_UrlStatus (
    Id int primary key NOT NULL,
    Name longtext  NOT NULL
);